﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace AreaInfo4JS.Web
{
    public partial class index : System.Web.UI.Page
    {
        private string sqlTmp = @"select *
                                  from VIW_Address
                                  where ProvinceName LIKE '{0}%' AND CityName LIKE '{1}%' AND CountyName LIKE '{2}%' AND TownName LIKE '{3}%'";

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string province = hid_province.Value.Replace("省","");
            string city = hid_city.Value.Replace("市", "");
            string country = hid_country.Value.Replace("区", "");
            string street = hid_street.Value.Replace("镇", "");

            string sql = string.Format(sqlTmp, province, city, country, street);
        }
    }
}